ABSTRACT
The research focused on the challenges of developing computerized information systems in a supermarket. The research study involved visiting Uchurni supermarket which uses manual file based system for managing inventory data, they face problems like data redundancy and inconsistency whereby some information are duplicated in several files . the file based system does not allow required data to be retrieved in a convenient and efficient manner thus difficult in accessing data. The objectives therefore include: to investigate and analyze the present system so as to identify in efficiencies into the current system of monitoring and controlling stock in the supermarket. Design, model and develop a computerized system for the organization: develop. Implement, test and validate the system ofrecord keeping in the school.The methods that were used to come up with the system included: for data collection ,self administered questionnaires, and structured interview for designing the database. Microsoft access was used and for the interface design, visual basics interface programming.Finally the implementation and the operation of the system was designed to accept only those who are the authorized to access the database from the visual interface using passwords and usernames granted by an administrator are used to gain access to the database.The research findings, the study were established causes of record keeping which is manual system of data entry, update, and storage and storage of data which is riddled with problems like poor storage, consumption of time during data entry, loss of records. The new system is computerized from entry of data processing to generating of reports. The system has speed, validation routines and is reliable. It is secure through a password however faces by challenges such as poverty, illiteracy, ignorance and others which hinders the development of computerized systems in organization.
Tab’e of content
DECLARATION
DEDICATION ii
APPROVAL
ACKNOWLEDGEMENTS iv
DEDICATION v
ABSTRACT vi
ABBREVIATION! ACRONYMS vii
LIST OF FIGURES viii
LIST OF TABLES ix
TABLE OF CONTENT x
CHAPTER ONE 1
1.0 Introduction 1
1.1 Background 1
1.2 Statement of the problem 1
1.3 OBJECTIVESOFTHESTUDY 2
1.3.1 Main Objective 2
1.3.2 Specific Objectives 2
1.4 Research Questions 2
1.5 SCOPE 2
1.5.1 Geographical scope 2
1.5.2 Research scope 3
1.6 Significance 3
1.7 Conceptual Framework 3
x
CHAPTER TWO .4
LITERATURE REVIEW 4
2.Olntroduction 4
2.1 Supply Chain Management System 4
2.2 information system 4
2.2.2 The roles of an information system 5
2.3 Computer Based information system (CBIS) 5
2.4 Management Information System 5
2.5 Database 7
2.6 Components of the database or DBMS environment 9
2.7 Tools used 9
CHAPTERTHREE 11
METHODOLOGY 11
3.0 Introduction 11
3.1 Research design 11
3.2 Population 11
3.3 Sample size 11
3.4 Sampling techniques 11
3.5 Research instruments 12
3.6 Data analysis 13
3.7 Development tools 13
3.8 Design tools 13
3.9 Implementing Tools 15
xi
CHAPTER FOUR . 16
SYSTEM INVESTIGATION ANALYSIS AND MODELLING 16
4.0 Introduction 16
4.1 System Specification Analysis and Requirements 16
4.1.2 System requirements 16
4.2 Functional requirements 18
4.3 System Design 19
4.3.1 Logical design 19
4.3.2 Physical design 25
4.4 System Testing, Implementation and Evaluation 27
4.4.1 The developed system 27
4.5 Program testing 36
4.6 System Conversion 37
4.7 User Training and Documentation 37
4.8 Operation and Support 38
CHAPTER FIVE 40
Discussion, Recommendations and Conclusion 40
Areas for Further Research 42
REFERENCES 43
APPENDIX A: QUESTIONNAIRE 44
APPENDIX B: BUDGETTABLE 46Tab’e of content
DECLARATION
DEDICATION ii
APPROVAL
ACKNOWLEDGEMENTS iv
DEDICATION v
ABSTRACT vi
ABBREVIATION! ACRONYMS vii
LIST OF FIGURES viii
LIST OF TABLES ix
TABLE OF CONTENT x
CHAPTER ONE 1
1.0 Introduction 1
1.1 Background 1
1.2 Statement of the problem 1
1.3 OBJECTIVESOFTHESTUDY 2
1.3.1 Main Objective 2
1.3.2 Specific Objectives 2
1.4 Research Questions 2
1.5 SCOPE 2
1.5.1 Geographical scope 2
1.5.2 Research scope 3
1.6 Significance 3
1.7 Conceptual Framework 3
x
CHAPTER TWO .4
LITERATURE REVIEW 4
2.Olntroduction 4
2.1 Supply Chain Management System 4
2.2 information system 4
2.2.2 The roles of an information system 5
2.3 Computer Based information system (CBIS) 5
2.4 Management Information System 5
2.5 Database 7
2.6 Components of the database or DBMS environment 9
2.7 Tools used 9
CHAPTERTHREE 11
METHODOLOGY 11
3.0 Introduction 11
3.1 Research design 11
3.2 Population 11
3.3 Sample size 11
3.4 Sampling techniques 11
3.5 Research instruments 12
3.6 Data analysis 13
3.7 Development tools 13
3.8 Design tools 13
3.9 Implementing Tools 15
xi
CHAPTER FOUR . 16
SYSTEM INVESTIGATION ANALYSIS AND MODELLING 16
4.0 Introduction 16
4.1 System Specification Analysis and Requirements 16
4.1.2 System requirements 16
4.2 Functional requirements 18
4.3 System Design 19
4.3.1 Logical design 19
4.3.2 Physical design 25
4.4 System Testing, Implementation and Evaluation 27
4.4.1 The developed system 27
4.5 Program testing 36
4.6 System Conversion 37
4.7 User Training and Documentation 37
4.8 Operation and Support 38
CHAPTER FIVE 40
Discussion, Recommendations and Conclusion 40
Areas for Further Research 42
REFERENCES 43
APPENDIX A: QUESTIONNAIRE 44
APPENDIX B: BUDGETTABLE 46
